<%@ include file="IsAdmin.jsp"%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<%
	String title = "SPMS: Homepage";
%>
<title><%=title%></title>
<link href="css/stylesheet.css" rel="stylesheet" type="text/css" />
<%@ include file="../master\head.jsp"%>
</head>
<body>
<div id="container">
<div id="wrapper">
<div id="sidebar">
<div id="sb_top"><%@ include file="../master\sbTop.jsp"%>
</div>

<div class="sb_content"><!--##########--> <!-- Start Menu --> <%@ include
	file="../master\menu.jsp"%> <!-- Profile --> <%@ include
	file="../master\profile.jsp"%> <!-- links --> <%@ include
	file="../master\links.jsp"%>
<div class="copyright"><%@ include file="../master\copyright.jsp"%>
</div>

</div>
<!-- /sb_content --></div>
<!-- /sidebar --> <!-- Top -->
<div id="header"><%@ include file="../master\header.jsp"%>
</div>


<!-- Start main content -->
<div id="content">
<div id="intro">
<div class="intro_t">
<h1><span>..</span>Welcome to<span>..</span></h1>
<h2>student project managment system</h2>

</div>
</div>
<!-- /intro -->

<h1>Change Enrolment Key</h1>
<form action="addProf.jsp" method="post">
<table>
<%@ page import="java.sql.*"%>
<%
try
{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection connection = DriverManager.getConnection(
			"jdbc:odbc:SPMS", "", "");
	Statement statement = connection.createStatement();
	ResultSet res = statement.executeQuery("select * from Professor");
	
	while(res.next())
	{
		out.print("<tr><td><input type='radio' name='prof' value=" + res.getString(1)
				+ " /></td>");
		out.print("<td>	"+res.getString(2)+" "+res.getString(3)+"</td></tr>");
			}
	out.print("<tr><td><input type='submit' value='Add' /></td></tr>");
	}
catch (ClassNotFoundException cnfe)
{
	out.println("No such class.");
}%>
</table>
</form>
</div>
<!-- /content --></div>
<!-- /wrapper -->
<div class="clear">&nbsp;</div>
<!-- Important! Fix the problem of height in Firefox --></div>
<!-- /Container -->


</body>
</html>